/*
MySQL Backup
Database: env
Backup Time: 2020-12-26 17:16:07
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `env`.`sys_dict_data`;
DROP TABLE IF EXISTS `env`.`sys_dict_type`;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8 COMMENT='字典数据表';
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='字典类型表';
BEGIN;
LOCK TABLES `env`.`sys_dict_data` WRITE;
DELETE FROM `env`.`sys_dict_data`;
INSERT INTO `env`.`sys_dict_data` (`dict_code`,`dict_sort`,`dict_label`,`dict_value`,`dict_type`,`css_class`,`list_class`,`is_default`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '性别男'),(2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '性别女'),(3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '性别未知'),(4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '显示菜单'),(5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '隐藏菜单'),(6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '正常状态'),(7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '停用状态'),(8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '正常状态'),(9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '停用状态'),(10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '默认分组'),(11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '系统分组'),(12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '系统默认是'),(13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '系统默认否'),(14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '通知'),(15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '公告'),(16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2020-12-12 14:55:18', '', NULL, '正常状态'),(17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '关闭状态'),(18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '新增操作'),(19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '修改操作'),(20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '删除操作'),(21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '授权操作'),(22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '导出操作'),(23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '导入操作'),(24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '强退操作'),(25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '生成操作'),(26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '清空操作'),(27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '正常状态'),(28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2020-12-12 14:55:19', '', NULL, '停用状态'),(29, 0, '待审核', '0', 'env_com_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 10:55:49', '', NULL, '新增公司信息后，即为待审核'),(30, 0, '有效	', '1	', 'env_com_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 10:56:11', '', NULL, NULL),(31, 0, '无效	', '2', 'env_com_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 10:56:29', '', NULL, NULL),(32, 0, '20人以下', '0', 'env_com_num', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:00:37', '', NULL, NULL),(33, 0, '20-150人', '1', 'env_com_num', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:00:52', '', NULL, NULL),(34, 0, '150人-500人', '2', 'env_com_num', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:01:03', '', NULL, NULL),(35, 0, '500-999人', '3', 'env_com_num', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:01:13', '', NULL, NULL),(36, 0, '1000人以上', '4', 'env_com_num', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:01:24', '', NULL, NULL),(37, 0, '编辑', '0', 'env_cv_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:02:04', '', NULL, NULL),(38, 0, '待审核', '1', 'env_cv_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:02:18', '', NULL, NULL),(39, 0, '发布', '2', 'env_cv_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:02:28', '', NULL, NULL),(40, 0, '取消发布', '3', 'env_cv_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:02:40', '', NULL, NULL),(41, 0, '求职简历', '0', 'env_cv_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:03:58', '', NULL, NULL),(42, 0, '专家简历', '1', 'env_cv_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:04:09', '', NULL, NULL),(43, 0, '在校-实习', '0', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:03', '', NULL, NULL),(44, 0, '在校-找工作	', '1', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:12', '', NULL, NULL),(45, 0, '在职-考虑机会	', '2', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:23', '', NULL, NULL),(46, 0, '在职-月内到岗	', '3', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:30', '', NULL, NULL),(47, 0, '在职-暂不考虑	', '5', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:38', '', NULL, NULL),(48, 0, '离职-立即到岗	', '6', 'env_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:07:47', '', NULL, NULL),(49, 0, '高/中专及以下', '1', 'env_qualifications', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:08:48', '', NULL, NULL),(50, 0, '大专', '2', 'env_qualifications', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:08:57', 'admin', '2020-12-20 11:09:16', NULL),(51, 0, '本科', '3', 'env_qualifications', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:09:10', '', NULL, NULL),(52, 0, '硕士', '4', 'env_qualifications', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:09:32', '', NULL, NULL),(53, 0, '博士及以上', '5', 'env_qualifications', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:09:42', '', NULL, NULL),(54, 0, '待沟通', '0', 'env_deliver_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:12:59', '', NULL, NULL),(55, 0, '已入职', '1', 'env_deliver_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:13:07', '', NULL, NULL),(56, 0, '不合适', '2', 'env_deliver_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:13:15', '', NULL, NULL),(57, 0, '已剔除', '3', 'env_deliver_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:13:32', '', NULL, NULL),(58, 0, '编辑', '0', 'env_position_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:14:53', '', NULL, NULL),(59, 0, '待审核', '1', 'env_position_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:15:02', '', NULL, NULL),(60, 0, '发布', '2', 'env_position_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:15:18', '', NULL, NULL),(61, 0, '取消发布', '3', 'env_position_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:15:28', '', NULL, NULL),(62, 0, '应届校招', '0', 'env_position_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:16:19', '', NULL, NULL),(63, 0, '实习生', '1', 'env_position_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:16:28', '', NULL, NULL),(64, 0, '社招', '2', 'env_position_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:16:34', '', NULL, NULL),(65, 0, '兼职', '3', 'env_position_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:16:42', '', NULL, NULL),(66, 0, '不限', '0', 'env_exp_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:17:26', '', NULL, NULL),(67, 0, '1-3年', '1', 'env_exp_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:17:34', '', NULL, NULL),(68, 0, '3-5年', '2', 'env_exp_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:17:42', '', NULL, NULL),(69, 0, '5-10年', '3', 'env_exp_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:17:52', '', NULL, NULL),(70, 0, '10年以上', '4', 'env_exp_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:18:02', '', NULL, NULL),(71, 0, '不限', '0', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:05', '', NULL, NULL),(72, 0, '中专及以上', '1', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:17', '', NULL, NULL),(73, 0, '大专及以上', '2', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:27', '', NULL, NULL),(74, 0, '本科及以上', '3', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:36', '', NULL, NULL),(75, 0, '硕士及以上', '4', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:45', '', NULL, NULL),(76, 0, '博士及以上', '5', 'env_edu_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:19:53', '', NULL, NULL),(77, 0, '面议', '0', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:20:25', '', NULL, NULL),(78, 0, '5k以下', '1', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:20:37', '', NULL, NULL),(79, 0, '5-8k', '2', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:20:45', '', NULL, NULL),(80, 0, '8-12k', '3', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:20:55', '', NULL, NULL),(81, 0, '12-18k', '5', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:21:12', '', NULL, NULL),(82, 0, '18-25k', '5', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:21:25', '', NULL, NULL),(83, 0, '25k以上', '6', 'env_salary_req', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:21:44', '', NULL, NULL),(84, 0, '招聘企事业', '0', 'env_user_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:22:20', '', NULL, NULL),(85, 0, '求职者', '1', 'env_user_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:22:27', '', NULL, NULL),(86, 0, '专家人才', '2', 'env_user_type', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:22:34', '', NULL, NULL),(87, 0, '在校生-在校/应届', '0', 'env_user_identity', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:23:04', '', NULL, NULL),(88, 0, '无经验-往届', '1', 'env_user_identity', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:23:12', '', NULL, NULL),(89, 0, '职场人-正式工作经历', '2', 'env_user_identity', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:23:22', '', NULL, NULL),(90, 0, '在校-实习', '0', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:24:32', '', NULL, NULL),(91, 0, '在校-找工作', '1', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:24:41', '', NULL, NULL),(92, 0, '在职-考虑机会', '2', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:24:54', '', NULL, NULL),(93, 0, '在职-月内到岗', '3', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:25:09', '', NULL, NULL),(94, 0, '在职-暂不考虑', '5', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:25:19', '', NULL, NULL),(95, 0, '离职-立即到岗', '6', 'env_user_work_status', NULL, NULL, 'N', '0', 'admin', '2020-12-20 11:25:31', '', NULL, NULL),(96, 0, '应用化工', '0', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:23:10', '', NULL, NULL),(97, 1, '煤炭深加工与利用', '1', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:23:23', '', NULL, NULL),(98, 2, '煤化工生产', '2', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:23:35', '', NULL, NULL),(99, 3, '矿物加工', '3', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:23:45', '', NULL, NULL),(100, 4, '选煤技术', '4', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:23:55', '', NULL, NULL),(101, 5, '工业分析技术', '5', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:24:05', '', NULL, NULL),(102, 6, '环境监测与控制', '6', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:24:18', '', NULL, NULL),(103, 7, '环境工程技术', '7', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:24:29', '', NULL, NULL),(104, 0, '环保要闻', '0', 'env_industry_info', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:28:53', '', NULL, NULL),(105, 1, '环保知识', '1', 'env_industry_info', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:29:02', '', NULL, NULL),(106, 2, '环保案例', '2', 'env_industry_info', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:29:10', '', NULL, NULL),(107, 3, '社会培训', '3', 'env_industry_info', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:29:23', '', NULL, NULL),(108, 0, '创业大赛', 'env_technology_communication', 'env_resume_major', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:29:50', '', NULL, '当前创业大赛专业类型为1时用，0：创新创业；1：孵化器信息；2：行业融资、3：创新科研'),(109, 0, '行业专家', '0', 'env_excellent_personnel', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:31:01', '', NULL, NULL),(110, 1, '环保大咖', '1', 'env_excellent_personnel', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:31:08', '', NULL, NULL),(111, 0, '优秀校友', '2', 'env_excellent_personnel', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:31:20', '', NULL, NULL),(112, 0, '优秀学员', '3', 'env_excellent_personnel', NULL, NULL, 'N', '0', 'admin', '2020-12-24 00:31:28', '', NULL, NULL),(113, 0, '甘肃省生态环境厅', '0', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:02:53', '', NULL, 'http://sthj.gansu.gov.cn/'),(114, 0, '甘肃省环境监测中心站', '1', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:03:07', '', NULL, 'http://www.ghjczxz.cn/'),(115, 0, '兰州市环境保护局', '2', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:03:23', '', NULL, 'http://sthjj.lanzhou.gov.cn/'),(116, 0, '嘉峪关市生态环境局', '3', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:03:40', '', NULL, 'http://sthjj.jyg.gov.cn/'),(117, 0, '金昌市生态环境局', '4', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:03:54', '', NULL, 'http://sthj.jcs.gov.cn/'),(118, 5, '白银市生态环境局', '5', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:04:14', '', NULL, 'http://www.baiyin.gov.cn/xwzx/bmkx/shbj/'),(119, 6, '天水市生态环境局', '6', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:04:32', '', NULL, 'http://www.tianshui.gov.cn/col/col401/index.html'),(120, 7, '酒泉市环境保护局', '7', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:04:50', '', NULL, 'http://sthj.jiuquan.gov.cn/'),(121, 8, '张掖市生态保护局', '8', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:05:08', '', NULL, 'http://www.zhangye.gov.cn/hbj/'),(122, 0, '定西市生态环境局', '9', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:15:17', '', NULL, 'http://sthj.dingxi.gov.cn/'),(123, 10, '平凉市生态环境局', '10', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:15:41', '', NULL, 'http://sthj.pingliang.gov.cn/'),(124, 11, '庆阳市生态环境局', '11', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:15:54', '', NULL, ' http://sthj.zgqingyang.gov.cn/'),(125, 12, '甘肃省环境科学设计研究院', '12', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:16:11', '', NULL, ' http://www.gsaers.com/'),(126, 13, '甘肃省环境科学学会', '13', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:16:25', '', NULL, ' https://www.gsses.org.cn/index.htm'),(127, 14, '甘肃省环境保护产业协会', '14', 'env_friendship_link', NULL, NULL, 'N', '0', 'admin', '2020-12-25 00:16:38', '', NULL, 'http://www.gsaepi.com/index.asp '),(128, 0, '科技服务', '0', 'env_technology_communication', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:47:08', '', NULL, NULL),(129, 1, '校企交流', '1', 'env_technology_communication', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:47:20', '', NULL, NULL),(130, 2, '技术攻关', '2', 'env_technology_communication', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:47:30', '', NULL, NULL),(131, 3, '技术标准', '3', 'env_technology_communication', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:47:39', '', NULL, NULL),(132, 0, '创新创业', '0', 'env_start_business', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:49:27', '', NULL, NULL),(133, 1, '孵化器信息', '1', 'env_start_business', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:49:37', '', NULL, NULL),(134, 2, '行业融资', '2', 'env_start_business', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:49:50', '', NULL, NULL),(135, 3, '创新科研', '3', 'env_start_business', NULL, NULL, 'N', '0', 'admin', '2020-12-25 22:50:01', '', NULL, NULL),(136, 0, '环境影响评价工程师', '0', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:34:54', '', NULL, NULL),(137, 1, '环评工程师', '1', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:03', '', NULL, NULL),(138, 2, '环境工程师', '2', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:11', '', NULL, NULL),(139, 3, 'HSE', '3', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:21', '', NULL, NULL),(140, 0, '列表', '0', 'env_category_type', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:30', '', NULL, NULL),(141, 4, '环境管理', '4', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:30', '', NULL, NULL),(142, 5, '电气工程师', '5', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:41', '', NULL, NULL),(143, 5, '封面', '1', 'env_category_type', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:43', 'admin', '2020-12-25 23:36:07', NULL),(144, 6, '废气处理工程师', '6', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:50', '', NULL, NULL),(145, 10, '链接', '2', 'env_category_type', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:55', '', NULL, NULL),(146, 7, '循环经济工程师', '7', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:35:58', '', NULL, NULL),(147, 8, '环境监测实验员', '8', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:36:08', '', NULL, NULL),(148, 9, '废水工艺工程师', '9', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:36:17', '', NULL, NULL),(149, 10, '环保工程师', '10', 'env_position_loop', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:36:28', '', NULL, NULL),(150, 0, '4-6k', '0', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:36:51', '', NULL, NULL),(151, 1, '8-12k', '1', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:36:59', '', NULL, NULL),(152, 2, '15k', '2', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:37:31', '', NULL, NULL),(153, 3, '15-18k', '3', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:37:40', '', NULL, NULL),(154, 4, '20k', '4', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:37:48', '', NULL, NULL),(155, 5, '20-25k', '5', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:37:57', '', NULL, NULL),(156, 6, '25-28k', '6', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:38:08', '', NULL, NULL),(157, 7, '30k以上', '7', 'env_hot_salary', NULL, NULL, 'N', '0', 'admin', '2020-12-25 23:38:17', '', NULL, NULL),(158, 0, '环境卫生', '1', 'env_content_type', NULL, NULL, 'N', '0', 'admin', '2020-12-26 03:35:48', '', NULL, NULL),(159, 5, '环保资讯', '2', 'env_content_type', NULL, NULL, 'N', '0', 'admin', '2020-12-26 03:36:01', '', NULL, NULL),(160, 10, '环保专家', '3', 'env_content_type', NULL, NULL, 'N', '0', 'admin', '2020-12-26 03:36:20', '', NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `env`.`sys_dict_type` WRITE;
DELETE FROM `env`.`sys_dict_type`;
INSERT INTO `env`.`sys_dict_type` (`dict_id`,`dict_name`,`dict_type`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '用户性别列表'),(2, '菜单状态', 'sys_show_hide', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '菜单状态列表'),(3, '系统开关', 'sys_normal_disable', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '系统开关列表'),(4, '任务状态', 'sys_job_status', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '任务状态列表'),(5, '任务分组', 'sys_job_group', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '任务分组列表'),(6, '系统是否', 'sys_yes_no', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '系统是否列表'),(7, '通知类型', 'sys_notice_type', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '通知类型列表'),(8, '通知状态', 'sys_notice_status', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '通知状态列表'),(9, '操作类型', 'sys_oper_type', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '操作类型列表'),(10, '系统状态', 'sys_common_status', '0', 'admin', '2020-12-12 14:55:17', '', NULL, '登录状态列表'),(11, '公司状态', 'env_com_status', '0', 'admin', '2020-12-20 10:55:07', '', NULL, '状态0：待审核；1：有效；2：无效：'),(12, '公司人数', 'env_com_num', '0', 'admin', '2020-12-20 11:00:14', '', NULL, '公司人数0:20人以下;1:20-150人;2:150-500人;3:500-999人;4:1000以上'),(13, '简历状态', 'env_cv_status', '0', 'admin', '2020-12-20 11:01:49', '', NULL, '状态0：编辑；1：待审核；2：发布：3：取消发布；'),(14, '简历类型', 'env_cv_type', '0', 'admin', '2020-12-20 11:03:19', 'admin', '2020-12-20 11:03:32', '类型0：求职简历；1：专家简历'),(15, '在职状态', 'env_work_status', '0', 'admin', '2020-12-20 11:06:46', '', NULL, '当前在职状态0：在校-实习；1：在校-找工作；2：在职-考虑机会；3：在职-月内到岗；5：在职-暂不考虑；6：离职-立即到岗'),(16, '学历', 'env_qualifications', '0', 'admin', '2020-12-20 11:08:22', '', NULL, '学历1:高/中专及以下；2：大专：3：本科；4：硕士；5：博士及以上'),(17, '简历处理状态', 'env_deliver_status', '0', 'admin', '2020-12-20 11:12:44', '', NULL, '状态0：待沟通；1：已入职；2：不合适；3、已剔除'),(18, '职位状态', 'env_position_status', '0', 'admin', '2020-12-20 11:14:29', '', NULL, '状态0：编辑；1：待审核；2：发布：3：取消发布；'),(19, '招聘类型', 'env_position_type', '0', 'admin', '2020-12-20 11:16:04', '', NULL, '招聘类型0:应届校招；1:实习生；2：社招：3:兼职'),(20, '经验要求', 'env_exp_req', '0', 'admin', '2020-12-20 11:17:14', '', NULL, '经验要求0：不限；1：1-3年；2：3-5年：3：5-10年；4：10年以上'),(21, '学历要求', 'env_edu_req', '0', 'admin', '2020-12-20 11:18:47', '', NULL, '学历要求0:不限;1:中专及以上;2:大专及以上;3:本科及以上;4:硕士及以上;5:博士及以上'),(22, '月薪资范围', 'env_salary_req', '0', 'admin', '2020-12-20 11:20:16', '', NULL, '月薪资范围:0:面议；1：5k以下；2：5-8k；3：8-12k；4：12-18k；5：18-25k；6：25k以上'),(23, '用户类型', 'env_user_type', '0', 'admin', '2020-12-20 11:22:07', '', NULL, '用户类型0：招聘企事业；1：求职者；2：专家人才'),(24, '经验类型', 'env_user_identity', '0', 'admin', '2020-12-20 11:22:50', 'admin', '2020-12-20 11:23:36', '求职身份类型为1时用，0：在校生-在校/应届；1：无经验-往届；2：职场人-正式工作经历'),(25, '求职状态', 'env_user_work_status', '0', 'admin', '2020-12-20 11:23:59', '', NULL, '当前求职状态类型为1时用，0：在校-实习；1：在校-找工作；2：在职-考虑机会；3：在职-月内到岗；5：在职-暂不考虑；6：离职-立即到岗'),(26, '简历专业', 'env_resume_major', '0', 'admin', '2020-12-24 00:22:56', '', NULL, '当前简历专业类型为1时用，0：应用化工；1：煤炭深加工与利用；2：煤化工生产、3：矿物加工；4：选煤技术；5：工业分析技术；6：环境监测与控制；7：环境工程技术'),(27, '行业资讯', 'env_industry_info', '0', 'admin', '2020-12-24 00:28:38', '', NULL, '当前简历专业类型为1时用，0：环保要闻；1：环保知识；2：环保案例、3：社会培训；'),(28, '优秀人才', 'env_excellent_personnel', '0', 'admin', '2020-12-24 00:30:43', '', NULL, NULL),(29, '友情链接', 'env_friendship_link', '0', 'admin', '2020-12-24 23:51:51', '', NULL, NULL),(30, '技术交流', 'env_technology_communication', '0', 'admin', '2020-12-25 22:46:53', '', NULL, NULL),(31, '创业大赛', 'env_start_business', '0', 'admin', '2020-12-25 22:49:11', '', NULL, NULL),(32, '热门职位轮播', 'env_position_loop', '0', 'admin', '2020-12-25 23:34:43', '', NULL, NULL),(33, '栏目分类类型', 'env_category_type', '0', 'admin', '2020-12-25 23:35:17', '', NULL, NULL),(34, '企业热招薪资', 'env_hot_salary', '0', 'admin', '2020-12-25 23:36:43', '', NULL, NULL),(35, '内容文章类型', 'env_content_type', '0', 'admin', '2020-12-26 03:35:23', '', NULL, NULL);
UNLOCK TABLES;
COMMIT;
